﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

/* Uncomment below script only when you deploy for first time*/
/*
INSERT INTO [DriveType] ([Id],[Value],[Description])VALUES(0,'Unknown','The type of drive is unknown.');
INSERT INTO [DriveType] ([Id],[Value],[Description])VALUES(1,'NoRootDirectory','The drive does not have a root directory.');
INSERT INTO [DriveType] ([Id],[Value],[Description])VALUES(2,'Removable','The drive is a removable storage device, such as a floppy disk drive or a USB flash drive.');
INSERT INTO [DriveType] ([Id],[Value],[Description])VALUES(3,'Fixed','The drive is a fixed disk.');
INSERT INTO [DriveType] ([Id],[Value],[Description])VALUES(4,'Network','The drive is a network drive.');
INSERT INTO [DriveType] ([Id],[Value],[Description])VALUES(5,'CDRom','The drive is an optical disc device, such as a CD or DVD-ROM.');
INSERT INTO [DriveType] ([Id],[Value],[Description])VALUES(6,'Ram','The drive is a RAM disk.');


INSERT INTO [EVENTType] ([Id],[Value],[Description])VALUES(1,'Error','An error event. This indicates a significant problem the user should know about; usually a loss of functionality or data.');
INSERT INTO [EVENTType] ([Id],[Value],[Description])VALUES(2,'Warning','A warning event. This indicates a problem that is not immediately significant, but that may signify conditions that could cause future problems.');
INSERT INTO [EVENTType] ([Id],[Value],[Description])VALUES(3,'Information','An information event. This indicates a significant, successful operation.');
INSERT INTO [EVENTType] ([Id],[Value],[Description])VALUES(4,'Security Audit Success','A success audit event. This indicates a security event that occurs when an audited access attempt is successful; for example, logging on successfully.');
INSERT INTO [EVENTType] ([Id],[Value],[Description])VALUES(5,'Security Audit Failure','A failure audit event. This indicates a security event that occurs when an audited access attempt fails; for example, a failed attempt to open a file.');
INSERT INTO [EVENTType] ([Id],[Value],[Description])VALUES(0,'Information','An information event. This indicates a significant, successful operation.');

INSERT INTO [NetworkInterfaceOperationalStatus] ([Id],[Value],[Description])VALUES(1,'Up','The network interface is up; it can transmit data packets.');
INSERT INTO [NetworkInterfaceOperationalStatus] ([Id],[Value],[Description])VALUES(2,'Down','The network interface is unable to transmit data packets.');
INSERT INTO [NetworkInterfaceOperationalStatus] ([Id],[Value],[Description])VALUES(3,'Testing','The network interface is running tests.');
INSERT INTO [NetworkInterfaceOperationalStatus] ([Id],[Value],[Description])VALUES(4,'Unknown','The network interface status is not known.');
INSERT INTO [NetworkInterfaceOperationalStatus] ([Id],[Value],[Description])VALUES(5,'Dormant','The network interface is not in a condition to transmit data packets; it is waiting for an external event.');
INSERT INTO [NetworkInterfaceOperationalStatus] ([Id],[Value],[Description])VALUES(6,'NotPresent','The network interface is unable to transmit data packets because of a missing component, typically a hardware component.');
INSERT INTO [NetworkInterfaceOperationalStatus] ([Id],[Value],[Description])VALUES(7,'LowerLayerDown','The network interface is unable to transmit data packets because it runs on top of one or more other interfaces, and at least one of these "lower layer" interfaces is down.');

INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(1,'Unknown','The interface type is not known.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(6,'Ethernet','The network interface uses an Ethernet connection. Ethernet is defined in IEEE standard 802.3.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(9,'TokenRing','The network interface uses a Token-Ring connection. Token-Ring is defined in IEEE standard 802.5.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(15,'Fddi','The network interface uses a Fiber Distributed Data Interface (FDDI) connection. FDDI is a set of standards for data transmission on fiber optic lines in a local area network.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(20,'BasicIsdn','The network interface uses a basic rate interface Integrated Services Digital Network (ISDN) connection. ISDN is a set of standards for data transmission over telephone lines.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(21,'PrimaryIsdn','The network interface uses a primary rate interface Integrated Services Digital Network (ISDN) connection. ISDN is a set of standards for data transmission over telephone lines.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(23,'Ppp','The network interface uses a Point-To-Point protocol (PPP) connection. PPP is a protocol for data transmission using a serial device.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(24,'Loopback','The network interface is a loopback adapter. Such interfaces are often used for testing; no traffic is sent over the wire.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(26,'Ethernet3Megabit','The network interface uses an Ethernet 3 megabit/second connection. This version of Ethernet is defined in IETF RFC 895.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(28,'Slip','The network interface uses a Serial Line Internet Protocol (SLIP) connection. SLIP is defined in IETF RFC 1055.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(37,'Atm','The network interface uses asynchronous transfer mode (ATM) for data transmission.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(48,'GenericModem','The network interface uses a modem.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(62,'FastEthernetT','The network interface uses a Fast Ethernet connection over twisted pair and provides a data rate of 100 megabits per second. This type of connection is also known as 100Base-T.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(63,'Isdn','The network interface uses a connection configured for ISDN and the X.25 protocol. X.25 allows computers on public networks to communicate using an intermediary computer.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(69,'FastEthernetFx','The network interface uses a Fast Ethernet connection over optical fiber and provides a data rate of 100 megabits per second. This type of connection is also known as 100Base-FX.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(71,'Wireless80211','The network interface uses a wireless LAN connection (IEEE 802.11 standard).');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(94,'AsymmetricDsl','The network interface uses an Asymmetric Digital Subscriber Line (ADSL).');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(95,'RateAdaptDsl','The network interface uses a Rate Adaptive Digital Subscriber Line (RADSL).');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(96,'SymmetricDsl','The network interface uses a Symmetric Digital Subscriber Line (SDSL).');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(97,'VeryHighSpeedDsl','The network interface uses a Very High Data Rate Digital Subscriber Line (VDSL).');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(114,'IPOverAtm','The network interface uses the Internet Protocol (IP) in combination with asynchronous transfer mode (ATM) for data transmission.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(117,'GigabitEthernet','The network interface uses a gigabit Ethernet connection and provides a data rate of 1,000 megabits per second (1 gigabit per second).');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(131,'Tunnel','The network interface uses a tunnel connection.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(143,'MultiRateSymmetricDsl','The network interface uses a Multirate Digital Subscriber Line.');
INSERT INTO [NetworkInterfaceType] ([Id],[Value],[Description])VALUES(144,'HighPerformanceSerialBus','The network interface uses a High Performance Serial Bus.');

INSERT INTO [ServiceStartMode] ([Id],[Value],[Description])VALUES(1,'Boot','Device driver started by the operating system loader (valid only for driver services).');
INSERT INTO [ServiceStartMode] ([Id],[Value],[Description])VALUES(2,'System','Device driver started by the operating system initialization process. This value is valid only for driver services.');
INSERT INTO [ServiceStartMode] ([Id],[Value],[Description])VALUES(3,'Auto','Indicates that the service is to be started (or was started) by the operating system, at system start-up. If an automatically started service depends on a manually started service, the manually started service is also started automatically at system startup.');
INSERT INTO [ServiceStartMode] ([Id],[Value],[Description])VALUES(4,'Manual','Indicates that the service is started only manually, by a user (using the Service Control Manager) or by an application.');
INSERT INTO [ServiceStartMode] ([Id],[Value],[Description])VALUES(5,'Disabled','Indicates that the service is disabled, so that it cannot be started by a user or application.');
INSERT INTO [ServiceStartMode] ([Id],[Value],[Description])VALUES(6,'Unknown','Some Error coudnt retrive status.');

INSERT INTO [ServiceStatus] ([Id],[Value],[Description])VALUES(1,'Stopped','The service is not running.');
INSERT INTO [ServiceStatus] ([Id],[Value],[Description])VALUES(2,'Start Pending','The service is starting.');
INSERT INTO [ServiceStatus] ([Id],[Value],[Description])VALUES(3,'Stop Pending','The service is stopping.');
INSERT INTO [ServiceStatus] ([Id],[Value],[Description])VALUES(4,'Running','The service is running.');
INSERT INTO [ServiceStatus] ([Id],[Value],[Description])VALUES(5,'Continue Pending','The service continue is pending.');
INSERT INTO [ServiceStatus] ([Id],[Value],[Description])VALUES(6,'Pause Pending','The service pause is pending.');
INSERT INTO [ServiceStatus] ([Id],[Value],[Description])VALUES(7,'Paused','The service is paused.');
INSERT INTO [ServiceStatus] ([Id],[Value],[Description])VALUES(8,'Unknown',NULL);


INSERT INTO [ServiceType] ([Id],[Value],[Description])VALUES(1,'Kernel Driver','A Kernel device driver such as a hard disk or other low-level hardware device driver.');
INSERT INTO [ServiceType] ([Id],[Value],[Description])VALUES(2,'File System Driver','A file system driver, which is also a Kernel device driver.');
INSERT INTO [ServiceType] ([Id],[Value],[Description])VALUES(3,'Adapter','A service for a hardware device that requires its own driver.');
INSERT INTO [ServiceType] ([Id],[Value],[Description])VALUES(4,'Recognizer Driver','A file system driver used during startup to determine the file systems present on the system.');
INSERT INTO [ServiceType] ([Id],[Value],[Description])VALUES(5,'Own Process','A Win32 program that can be started by the Service Controller and that obeys the service control protocol. This type of Win32 service runs in a process by itself.');
INSERT INTO [ServiceType] ([Id],[Value],[Description])VALUES(6,'Share Process','A Win32 service that can share a process with other Win32 services.');
INSERT INTO [ServiceType] ([Id],[Value],[Description])VALUES(7,'Interactive Process','A service that can communicate with the desktop.');
INSERT INTO [ServiceType] ([Id],[Value],[Description])VALUES(8,'Unknown','Some Error coudnt retrive status.');

*/